<?php
	require_once "db_connection.php";
	$sql = mysql_query("SELECT vehicletype, vehiclemodel, capacity FROM vehicles ORDER BY vehicletype, capacity");	
						
	$acc_num = 0;
	$class_alternate = "";
	while($row = mysql_fetch_array($sql, MYSQL_ASSOC))
	{
		$acc_num=$acc_num+1;
		echo"<tr class='". $class_alternate ."'>
						<td>".$acc_num."</td>
						<td><b>" .$row['vehicletype']. "</b></td>
						<td>" .$row['vehiclemodel']. "</td>
						<td>" .$row['capacity']. "</td>
						<td class='options-width'>
						<a href='' title='Edit' class='icon-1 info-tooltip'></a>
						<a href='' title='Delete' class='icon-2 info-tooltip'></a>
						<a href='' title='View' class='icon-5 info-tooltip'></a>
						</td>
					</tr> ";
		if($class_alternate==""){ $class_alternate="alternate-row";}
		else{$class_alternate="";}				
	}
?>
